USE [Monitoring]
GO

--|--------------------------------------------------------------------------------
--| [GetGameByID] - Insert Procedure Script for Game
--|--------------------------------------------------------------------------------
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[GetGameByID]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) 
  DROP PROCEDURE [dbo].[GetGameByID]
GO

CREATE PROCEDURE [dbo].[GetGameByID]
(
	@ID int
)
AS
	SET NOCOUNT ON

	SELECT
		[ID],
		[TeamID],
		[Name],
		[Description],
		[CreationDate]
	FROM 
Game
	WHERE
		[ID] = @ID
	
GO



